UBB.Developers Forums UBB.threads 7 Development How Do I? change posted image urls

all over my forum, there are posts with various images on my server. all of them are at the same url, like this:

http://www.robkamphausen.com/image/place/image1.jpg
http://www.robkamphausen.com/image/place/image2.jpg
http://www.robkamphausen.com/image/place/image3.jpg

if i wanted to move all of those images, is there any command i can enter that will automatically change the url of the posts? like, something that will universally change all references of:
http://www.robkamphausen.com/image/place/

to:
http://www.robkamphausen.com/image/place/boards/

?

Is the URL of the images in the content of the posts itself?

UPDATE w3t_Posts SET B_Body = REPLACE(B_Body, 'robkamphausen.com/image/place/','robkamphausen.com/image/place/boards/');

[]Medar said:
Is the URL of the images in the content of the posts itself? [/]

naw, its not the actual URL. its a posted image, so it'll look like this:

[]Anno said:
UPDATE w3t_Posts SET B_Body = REPLACE(B_Body, 'robkamphausen.com/image/place/','robkamphausen.com/image/place/boards/'); [/]

so this'll actually change the image URL? (NOT just a hyper link?)

What Anno said

That will change every instance in your B_Body (Post Content field) of:

robkamphausen.com/image/place/

Into:

robkamphausen.com/image/place/boards/

Test a single post first, make sure it is what you are wanting to do. Add a:

WHERE B_Number=xxxxx;

on the end to test a single post.

awesome!

i'll play around with this tonight -- that should definitely help me organize stuff on my server a lot more efficiently.

thanks guys!

>Test a single post first, make sure it is what you are wanting to do.
Ah, yes, good advice.
And for an additional measure, make sure you have a recent database backup.

btw, i've used this a few times and it works GREAT!!!

thanks